Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_LOCK_INTERNAL

`DBA_LOCK_INTERNAL` displays a row for each lock or latch that is being held, and one row for each outstanding request for a lock or latch.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`SESSION_ID` | `NUMBER` |  | Session holding or acquiring the lock
`LOCK_TYPE` | `VARCHAR2(56)` |  | Lock type See Also: For a listing of lock types, see Appendix D, "Oracle Enqueue Names"
`MODE HELD` | `VARCHAR2(40)` |  | Lock mode
`MODE REQUESTED` | `VARCHAR2(40)` |  | Lock mode requested
`LOCK_ID1` | `VARCHAR2(1130)` |  | Type-specific lock identifier, part 1
`LOCK_ID2` | `VARCHAR2(40)` |  | Type-specific lock identifier, part 2